delete from boss_t_pay_account where year =2020;
delete from boss_t_pay_busvou_acctmdl where year = 2020;

INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('ED4BC53B90B602FA648CD9DC59B7C755', '400201', '上年结转', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0F734F7F7FA65E5E4BB9763E2A7A35E0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('8ACC1DD33C074788AC17C953632C5AEC', '631', '单位指标', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', '2', 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', 'virtual-budget', 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('B84AAF0EDEAFA080599E51788DE79B8F', '5201', '确认支付', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('7AFD43F150D5C5E9FDFBC6BBF06FC70D', '9004', '已核销收入', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('B8739E94648744DC852495AE072D69E7', '661', '暂存支出科目', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', '2', 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', 'virtual-pay', 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('974AFE2EC5CBFEFD31C8305140B7EDCC', '4001', '年初预算支出', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('4278BE5788270BA1DC2011D29BCF1B6A', '4004', '收回以前年度已列支存量资金', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('085FE3977B80D00963BA85186AFB3DE1', '410201', '本级收入变动', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', 'D03A40014F8EDDEF6C6D87AEEAABBE01', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('A5876A98A768CD1829E19E615C6A51B8', '400206', '调入预算稳定调节基金', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0F734F7F7FA65E5E4BB9763E2A7A35E0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('3FFE24125A8CB61068076013EF1D8050', '500202', '下级指标', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '48A16E06B8ED3F96A92A50CA42CCDF07', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('07E7CEC30E46E9999AE3315043EC5E84', '500203', '上解上级指标', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '48A16E06B8ED3F96A92A50CA42CCDF07', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('267194191E3BFB4287C442180E702D60', '3002', '预算稳定调节基金', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('E52446280C353A7FBE94A73DA842621C', '4101', '年初预算收入', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('A58C45296D8664D78A62A95A604C100D', '9001', '已核销支出', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('C8631762BB5046C705D8B15538C1FE9B', '5301', '收入指标', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('BB53CCE93325E973B913E037DCC7E292', '500102', '处室指标', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '1444CE89CA1BD6F29E3E0AE87EF217FD', 'F03171C52C39B8C04C91048C9538075D', '30', 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('CCBB352E4C7B6BBF4C4AC8F14CC89483', '500204', '单位可执行指标', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '48A16E06B8ED3F96A92A50CA42CCDF07', 'F03171C52C39B8C04C91048C9538075D', '32', 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('081A7D5A493DE61CEBDDFCF6D1771999', '3003', '收入差额', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('96DB95F40FB1DAD5B1B1053715754C71', '4003', '上年列支结转', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('E0FEA8FBBCD1F6B5E0C86ABB8AEEA62D', '9003', '指标结转', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('C2751EF6E0034CD0007D54260894C2BD', '1001', '财政支出预算', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('1114DAA5B21AC64F5715AA3997F774B3', '500103', '处室指标（无上游）', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '1444CE89CA1BD6F29E3E0AE87EF217FD', 'F03171C52C39B8C04C91048C9538075D', '31', 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('D44CB57B2D914D3F9FA3514A498C847C', '2001', '预安排指标', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '85235416CAE890E93F034541411E757E', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('0F734F7F7FA65E5E4BB9763E2A7A35E0', '4002', '预算支出变动', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('88C17E4AB4E8493E2745FA759190CCFC', '400203', '下级上解', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0F734F7F7FA65E5E4BB9763E2A7A35E0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('437C2D6FF3F76BC50F30C933F7B6DA13', '400204', '增发债务', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0F734F7F7FA65E5E4BB9763E2A7A35E0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('33141C9B5FDDD52C2D82D577FC45550C', '410202', '转移性收入变动', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', 'D03A40014F8EDDEF6C6D87AEEAABBE01', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('ED7553AF523F0B39FC94B39A0646D7A0', '500201', '本级指标', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '48A16E06B8ED3F96A92A50CA42CCDF07', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('12391F20A0D00655BB4CBC74F0ECA028', '500100', '虚拟指标', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '1444CE89CA1BD6F29E3E0AE87EF217FD', 'F03171C52C39B8C04C91048C9538075D', 'virtual-all', 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('ACC91F20A0D00655BB4CBC74F0ECA028', '500101', '总指标', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '1444CE89CA1BD6F29E3E0AE87EF217FD', 'F03171C52C39B8C04C91048C9538075D', '51', 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('EBA3C7371D48E716450D8CFF31DB4027', '400202', '上级补助', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0F734F7F7FA65E5E4BB9763E2A7A35E0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('1444CE89CA1BD6F29E3E0AE87EF217FD', '5001', '待分指标', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('6E506B3B7AB0434EEDFFD8F8CD9EA31C', '1002', '盘活存量资金', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('85954D7E114612659364042F902ED771', '500205', '单位可执行指标（无上游）', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '48A16E06B8ED3F96A92A50CA42CCDF07', 'F03171C52C39B8C04C91048C9538075D', '33', 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('9D6C71E5189DA5D8959400FD4D3BD2FD', '635', '可执行指标', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', '1', 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', '8', 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('A0B20BFAC7183413E6E3B369ECE08963', '400205', '调入其他资金', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0F734F7F7FA65E5E4BB9763E2A7A35E0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('D03A40014F8EDDEF6C6D87AEEAABBE01', '4102', '预算收入变动', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('48A16E06B8ED3F96A92A50CA42CCDF07', '5002', '可支付指标', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('1CE66F6905D24A8F314475B38C80BADE', '3001', ' 支出指标结余', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '8259A442D75B4502A3A09E5AB2D61A60', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('B25A2D410F2705068A0B37F4A88554C1', '400207', '超收安排', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0F734F7F7FA65E5E4BB9763E2A7A35E0', 'F03171C52C39B8C04C91048C9538075D', NULL, 0);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('29BE185FAA92B21FA421DC48DBCC0937', '651', '用款计划', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', '2', 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', 'FA33F4B86E4943D39C57C24C6646FDD4', 1);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('7FDCCAD410DD3448B57352BCB7C32AA0', '9002', '计划结转', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 1);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('AD93CE06A3E593B19FDC7ABCE6E399EB', '6501', '计划冻结科目', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 1);
INSERT INTO boss_t_pay_account("guid", "code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", "year", "province", "superguid", "stid", "coaguid", "balanceperiodtype") VALUES ('AE44760E364F39A8372FF551C7FB2B5E', '5101', '可执行计划', 1, 'dfl2020', '2019-11-25 14:38:39', '2019-11-25 14:38:39', 'dfl2020', NULL, 2020, '610000', '0', 'F03171C52C39B8C04C91048C9538075D', NULL, 1);


INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('D98E76DE5D8BA8A925FCABFD9DBFD596', 2020, '610000', '03FC4ABAF8B6D312EB216E43D390488A', 'BB53CCE93325E973B913E037DCC7E292', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('7D7B7A8C56CA41EE35CF5C3A974DD709', 2020, '610000', '03FC4ABAF8B6D312EB216E43D390488A', 'ACC91F20A0D00655BB4CBC74F0ECA028', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('2FE8BEC9E10B539EF7312E6421B5ABEE', 2020, '610000', '098E9DE5993CEFD8A16A684D8758120E', '7AFD43F150D5C5E9FDFBC6BBF06FC70D', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('6EF85AE918BFBA06E89D5D9534D729C0', 2020, '610000', '098E9DE5993CEFD8A16A684D8758120E', '081A7D5A493DE61CEBDDFCF6D1771999', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('5B2D8A9DF012AF20AB033CCB72B25DDC', 2020, '610000', '0EE24F055CC4CF3D4DD6E2537C1E4181', 'BB53CCE93325E973B913E037DCC7E292', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('A629D5C06B36841C4B4A18AA857464B5', 2020, '610000', '0FC6CA573F159ACF4AADBE1968C76DDA', 'BB53CCE93325E973B913E037DCC7E292', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('7BAE3DE6D7C975DE51A3DF3222A56147', 2020, '610000', '11A2417622CDA3A26C43385413D3AB7E', '29BE185FAA92B21FA421DC48DBCC0937', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('E071E99EFBBFE8D8477014FBEAF7BA77', 2020, '610000', '11A2417622CDA3A26C43385413D3AB7E', '8ACC1DD33C074788AC17C953632C5AEC', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('429A734D49B80EC8CBBEC8D1BAFE1614', 2020, '610000', '1A9565271962E90E3DD244F483DFDC8B', 'B8739E94648744DC852495AE072D69E7', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('5A245A84A8FD84D71F54EB320F16E1AC', 2020, '610000', '1A9565271962E90E3DD244F483DFDC8B', '29BE185FAA92B21FA421DC48DBCC0937', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('E358CB598554DAFF73EAB6184560B126', 2020, '610000', '1F3AC3B018F01BC8BA83144677EBCC40', '85954D7E114612659364042F902ED771', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('CFBEA5E71D826711D2DCCB19B6093436', 2020, '610000', '2618ED22C0DF6CB971ACC7227274CFAA', 'C2751EF6E0034CD0007D54260894C2BD', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('3F30A26CAC52ABFE6C5299BE12FC356F', 2020, '610000', '2618ED22C0DF6CB971ACC7227274CFAA', 'D44CB57B2D914D3F9FA3514A498C847C', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('46435B7EC9BA2010E8458152659CB9CD', 2020, '610000', '2DD7B6D6BFD8700EC468DC667A3F37C7', 'D44CB57B2D914D3F9FA3514A498C847C', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('C68D113C4B769C4B8641E2C7E457B974', 2020, '610000', '2DD7B6D6BFD8700EC468DC667A3F37C7', '3FFE24125A8CB61068076013EF1D8050', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('80AA07E9205843254647DB7C05144F5E', 2020, '610000', '2DDBFF35A946DA288669767EFBA9A16C', 'CCBB352E4C7B6BBF4C4AC8F14CC89483', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('575FFD6DDF62E9F5B3A4A3DB05C8ADBF', 2020, '610000', '2DDBFF35A946DA288669767EFBA9A16C', '29BE185FAA92B21FA421DC48DBCC0937', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('0F0B5C8B5F841AAF8AC902620F75D52B', 2020, '610000', '2F84EF607927CBB1BCE83C8BD4CCD978', 'EBA3C7371D48E716450D8CFF31DB4027', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('DBD70F7AB302EAAEC937ABA42993FC67', 2020, '610000', '2F84EF607927CBB1BCE83C8BD4CCD978', 'C8631762BB5046C705D8B15538C1FE9B', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('E2D4BE2960C178458C38D13FD98F205D', 2020, '610000', '300EA7D13767955191AB5FB4F2E30E34', 'CCBB352E4C7B6BBF4C4AC8F14CC89483', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('A9B95153A4BA57117269C28168B2E9F8', 2020, '610000', '33E4D8B11FC74F54A1E620B040B92476', 'BB53CCE93325E973B913E037DCC7E292', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('2BE8D562E529938F6EB5CCF232A5AFF4', 2020, '610000', '33E4D8B11FC74F54A1E620B040B92476', '5DF248BCFB6347D4AF2328917A714AC4', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('91E76325ADDF90AEE2060C9F3DAEA157', 2020, '610000', '3950A4E05C086BBE247E3854E6D2E597', 'EBA3C7371D48E716450D8CFF31DB4027', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('1A3D45AF0BCB739DB03A0E75C9A96D4E', 2020, '610000', '3950A4E05C086BBE247E3854E6D2E597', 'C2751EF6E0034CD0007D54260894C2BD', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('AC4CEB0A0FED42FA9B9D78EA02CDD66A', 2020, '610000', '3C6DE06C7337230C378EA854718292C8', 'AD93CE06A3E593B19FDC7ABCE6E399EB', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('EE4C5B004F46AB327397A6C4C4266AB1', 2020, '610000', '3C6DE06C7337230C378EA854718292C8', '29BE185FAA92B21FA421DC48DBCC0937', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('97C9E6E8BD2DD4D6C280CD9C79976083', 2020, '610000', '4682BC0D9527A885CAA83F1764161B10', 'C2751EF6E0034CD0007D54260894C2BD', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('778D19AEDC48F874CB630C80EEAE686A', 2020, '610000', '4682BC0D9527A885CAA83F1764161B10', '88C17E4AB4E8493E2745FA759190CCFC', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('A48BBB87684C839827A1B90857548238', 2020, '610000', '4CEF2979B91F04C2524B5AFD0EEB1C8C', '1CE66F6905D24A8F314475B38C80BADE', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('A893DE4F100EAA570D94B858DA1EF0CD', 2020, '610000', '54BB3E8E5EA05401D0E8725019B66CFA', 'ACC91F20A0D00655BB4CBC74F0ECA028', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('F5F0108174DEF95CD1BF8ACF0FF29FA2', 2020, '610000', '55E01CEA5B6750A36C8B667ADE149148', '29BE185FAA92B21FA421DC48DBCC0937', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('61A14CC0A95608B04B195ACCFC6CCF4A', 2020, '610000', '55E01CEA5B6750A36C8B667ADE149148', 'CCBB352E4C7B6BBF4C4AC8F14CC89483', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('E2DD43660A904CEB8D819F0B4FC254FA', 2020, '610000', '5852768F741B5E09EBE08CC0A5EBE7A3', 'C2751EF6E0034CD0007D54260894C2BD', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('F162EC70212AE26BC03C7B1C313E790B', 2020, '610000', '5852768F741B5E09EBE08CC0A5EBE7A3', 'C8631762BB5046C705D8B15538C1FE9B', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('D75DD2E1277CB5B9CAADFBF682D8AEEB', 2020, '610000', '60B7FCB8504544EFBA2D7AE2622DA2D8', '0221612E8098465995C0FA35FBDA9CBB', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('5392E2874AB4554C3C5151099690784A', 2020, '610000', '60B7FCB8504544EFBA2D7AE2622DA2D8', 'CCBB352E4C7B6BBF4C4AC8F14CC89483', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('8A7B94953693520FC77534A5BBD45896', 2020, '610000', '622E16F9B325CE53E07D48B09BBF0E80', 'C2751EF6E0034CD0007D54260894C2BD', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('C9BF934522C3608FA2E31EC83748D3CE', 2020, '610000', '622E16F9B325CE53E07D48B09BBF0E80', '1444CE89CA1BD6F29E3E0AE87EF217FD', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('729E7F5516840E221AC4AA3890CBA077', 2020, '610000', '6E0DAAAC54C78AA4C22A1CA07B639E8C', '29BE185FAA92B21FA421DC48DBCC0937', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('0A8F3FEBFC82E6525D3F39D2891EDF11', 2020, '610000', '6E0DAAAC54C78AA4C22A1CA07B639E8C', 'B8739E94648744DC852495AE072D69E7', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('548A73D26339A9C8EF3E896264A38DE3', 2020, '610000', '714B1F4F7A88438848B0D70F3C4CFC9C', 'CCBB352E4C7B6BBF4C4AC8F14CC89483', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('52BD34AD094521C527D89626F7C1AF17', 2020, '610000', '714B1F4F7A88438848B0D70F3C4CFC9C', '8ACC1DD33C074788AC17C953632C5AEC', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('F0EBED1677F9AB426AEBADE1C8A23A10', 2020, '610000', '72F417CC03D6C7D1391B9A9B9CAFB398', '1CE66F6905D24A8F314475B38C80BADE', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('1593A7786EC2F76B54A98F084E78900F', 2020, '610000', '77997A412E31C8369CEE494F230A63AE', 'ACC91F20A0D00655BB4CBC74F0ECA028', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('A56D69867202158A56012408A3D9B91E', 2020, '610000', '77997A412E31C8369CEE494F230A63AE', 'BB53CCE93325E973B913E037DCC7E292', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('AFE700C4D539AA62432CE924E1A4CAC3', 2020, '610000', '7A3E878C02D2492C88A48D7BC2F43EB1', 'ACC91F20A0D00655BB4CBC74F0ECA028', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('DCEDA7C4F774FDEBF5ECE55F6FA6AC99', 2020, '610000', '7F80781AF4F5E728DEA59529E8DDC2EF', 'D44CB57B2D914D3F9FA3514A498C847C', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('A8A65D0729EF247A875F7433D79753EA', 2020, '610000', '7F80781AF4F5E728DEA59529E8DDC2EF', 'ED7553AF523F0B39FC94B39A0646D7A0', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('EBFA6F5F06B4C074ED82BEE87CD85BD5', 2020, '610000', '86B1F964F8467758696BC67FBA1D57E3', 'BB53CCE93325E973B913E037DCC7E292', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('A8257CD4D127995258CB30415FBE240C', 2020, '610000', '86B1F964F8467758696BC67FBA1D57E3', 'CCBB352E4C7B6BBF4C4AC8F14CC89483', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('2BC58C69C308497AD7886193A61C74E3', 2020, '610000', '8899214B18924E3A5E37F4E85C710B61', '974AFE2EC5CBFEFD31C8305140B7EDCC', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('314A248E5AD3F2D2B8804FAAEE067906', 2020, '610000', '8899214B18924E3A5E37F4E85C710B61', 'C2751EF6E0034CD0007D54260894C2BD', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('F9C7D8B4D6C2D9A5765F21869511BDF5', 2020, '610000', '8A0B39A8B338BAF0866B60496C53287D', '8ACC1DD33C074788AC17C953632C5AEC', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('F11FE8E6FFDE7DF253445AAD5DA65E9B', 2020, '610000', '8A0B39A8B338BAF0866B60496C53287D', 'CCBB352E4C7B6BBF4C4AC8F14CC89483', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('AE1A881C498D0B76484DC7104E5F55A5', 2020, '610000', '9A0D09AC71554675BF9D868535016030', '5DF248BCFB6347D4AF2328917A714AC4', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('B00E345F52C1024CFCDCF87C90CB31A2', 2020, '610000', '9A0D09AC71554675BF9D868535016030', 'BB53CCE93325E973B913E037DCC7E292', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('8F313EA2BFB03732F564F9D532BA9500', 2020, '610000', 'A517A40FD9946C425A232469D819782F', 'A58C45296D8664D78A62A95A604C100D', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('3763D1DAA8BA4AD3F9BCBE1CF639F109', 2020, '610000', 'A517A40FD9946C425A232469D819782F', '6E506B3B7AB0434EEDFFD8F8CD9EA31C', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('7159DBB0003AABDEB16147CBAF0F05AA', 2020, '610000', 'AF5D2CFA27B2E913B7CC9F19F33EDEC2', 'CCBB352E4C7B6BBF4C4AC8F14CC89483', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('42A8D123A1C70AFBD61BC34DD21B65E4', 2020, '610000', 'AF5D2CFA27B2E913B7CC9F19F33EDEC2', 'BB53CCE93325E973B913E037DCC7E292', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('225C3AE94CC3F02EC3048A01D75F0F0D', 2020, '610000', 'B5C3CD9970D1417C9B1D8F989CAD895D', 'CCBB352E4C7B6BBF4C4AC8F14CC89483', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('9B880DDF4B439328A60516F24F19FE86', 2020, '610000', 'B5C3CD9970D1417C9B1D8F989CAD895D', '0221612E8098465995C0FA35FBDA9CBB', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('606566A2B5A17B568BD6893C8563DF3F', 2020, '610000', 'BA55CD8E39946DC8BCA8E5A88492B213', '29BE185FAA92B21FA421DC48DBCC0937', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('F887610B407B1B3C20A2F3AE9E0B1D62', 2020, '610000', 'BA55CD8E39946DC8BCA8E5A88492B213', 'AD93CE06A3E593B19FDC7ABCE6E399EB', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('2361C822E180B206C09EF449920C121D', 2020, '610000', 'BF4E84F9C72D0720706AA75E7A1E38AC', 'C8631762BB5046C705D8B15538C1FE9B', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('49E028E70A02A411780993EFC20470B2', 2020, '610000', 'C0CC16597AE75BCB8E4455D0C7B721F8', 'B8739E94648744DC852495AE072D69E7', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('FD838754DAA3B76F20799E1B1C82490C', 2020, '610000', 'C0CC16597AE75BCB8E4455D0C7B721F8', '8ACC1DD33C074788AC17C953632C5AEC', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('7BD1C950FF8BB0C2779D571420B7E700', 2020, '610000', 'CCD9D24B828B5F2E359DA56699E923DC', '081A7D5A493DE61CEBDDFCF6D1771999', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('B0A29673CD43C9C206AE5EBAAC6D95FE', 2020, '610000', 'CFF7E610073BC1EAB3541B2236090C66', '8ACC1DD33C074788AC17C953632C5AEC', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('F17FA5BBF36BA289A44A792CAD0D8647', 2020, '610000', 'CFF7E610073BC1EAB3541B2236090C66', 'B8739E94648744DC852495AE072D69E7', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('230FB4319DCAA74CF9A330EFB42EF85F', 2020, '610000', 'D2411583CE699C9E10D1BF95591B24F9', 'BB53CCE93325E973B913E037DCC7E292', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('7CCD6A3CB2DB7517E847F9309A182E8B', 2020, '610000', 'E1E82A189F40AB438A4D2274D13B42DA', 'AE44760E364F39A8372FF551C7FB2B5E', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('DF8091F348DE20A9A175612B5FCF9658', 2020, '610000', 'E1E82A189F40AB438A4D2274D13B42DA', 'B84AAF0EDEAFA080599E51788DE79B8F', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('91BA50CEEDE137E569AB805AD0A7AFDF', 2020, '610000', 'E2A5D3E65E5930B85772E3D40D936C24', 'ED7553AF523F0B39FC94B39A0646D7A0', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('D0852FD24F6B087AA5DC265E2CA1FA3E', 2020, '610000', 'E2A5D3E65E5930B85772E3D40D936C24', 'ED7553AF523F0B39FC94B39A0646D7A0', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('90212295F6F6E188225A4BB202027376', 2020, '610000', 'E7DB57A9E3AE7EA809F7D4CEEE7936D9', 'ED7553AF523F0B39FC94B39A0646D7A0', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('FFCE511F56D6B0272A0EDE8D90E6FA61', 2020, '610000', 'E7DB57A9E3AE7EA809F7D4CEEE7936D9', 'AE44760E364F39A8372FF551C7FB2B5E', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('66DF308722E3E29EBFB62F42F899B0EA', 2020, '610000', 'E924B69B53A979CE6EE899BD537AFD17', 'ED7553AF523F0B39FC94B39A0646D7A0', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('87DC4668A974345EFD8888453B2F0ED6', 2020, '610000', 'E924B69B53A979CE6EE899BD537AFD17', 'C2751EF6E0034CD0007D54260894C2BD', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('A083FEF6789982444D2F8DBAE347F043', 2020, '610000', 'EB7CEAE410E82432690D24DD5655E9F4', 'C2751EF6E0034CD0007D54260894C2BD', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('96988ECC0C668A594AD9738C591D96BC', 2020, '610000', 'EB7CEAE410E82432690D24DD5655E9F4', '1444CE89CA1BD6F29E3E0AE87EF217FD', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('108AF58AE6C96B79500305BC05933A8B', 2020, '610000', 'EC50AB2FE7DF09F8B761DD5C3DC61FC9', 'C2751EF6E0034CD0007D54260894C2BD', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('8AEAC71366EB98508FD03677C3C761FE', 2020, '610000', 'EE4976CB4773733A1BDFAAF6B162BE27', 'C8631762BB5046C705D8B15538C1FE9B', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('CE9119A7E06577A632562BE756CDC06F', 2020, '610000', 'EE4976CB4773733A1BDFAAF6B162BE27', '7AFD43F150D5C5E9FDFBC6BBF06FC70D', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('69FFF47BC31000998A6F4165C1A72CBB', 2020, '610000', 'EE9FE1C4F06063459BD9D8F3DF06E01C', 'B8739E94648744DC852495AE072D69E7', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('B6B9E573F71919744009A06D1703617B', 2020, '610000', 'EE9FE1C4F06063459BD9D8F3DF06E01C', 'CCBB352E4C7B6BBF4C4AC8F14CC89483', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('E9A3B606E34AB4BB7D16892E22E5F096', 2020, '610000', 'F2EA59698CD4DEE2059D1FEBF981E7BF', '1444CE89CA1BD6F29E3E0AE87EF217FD', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('F8943132667BAF4068FB02787F25630D', 2020, '610000', 'F2EA59698CD4DEE2059D1FEBF981E7BF', 'E0FEA8FBBCD1F6B5E0C86ABB8AEEA62D', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('E2C3D45571D88102F39CA4DF7B40A931', 2020, '610000', 'F524593A5DEB90546434A40681ADC458', 'CCBB352E4C7B6BBF4C4AC8F14CC89483', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('F43D6305D1C091F7F804DF9356396B10', 2020, '610000', 'F524593A5DEB90546434A40681ADC458', 'B8739E94648744DC852495AE072D69E7', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('BBE2A01CE26CA293CD495472C104166E', 2020, '610000', 'F6193968719958268FF26C793245DE7C', 'C2751EF6E0034CD0007D54260894C2BD', 1, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO boss_t_pay_busvou_acctmdl("guid", "year", "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version") VALUES ('99A60B968FD7D8CBF50EFBE5A7A3099C', 2020, '610000', 'F6193968719958268FF26C793245DE7C', 'ED7553AF523F0B39FC94B39A0646D7A0', 0, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);

insert into boss_t_pay_account
select "guid", a."code", "name", "enable", "creater", "createtime", "lasttime", "lastuser", "version", a."year", b.code as "province", "superguid", "stid", "coaguid", "balanceperiodtype" from boss_t_pay_account a left join  (select DISTINCT code ,year from fasp_t_pubadmdiv where year = 2020 and province= '610000' and code  != '610000' and length(code) = 6) b  on a.year = b.year where a.year =2020 and a.province = '610000';

insert into boss_t_pay_busvou_acctmdl
select "guid", a."year", b.code as "province", "voutypeguid", "accountguid", "entryside", "isprimarysource", "isprimarytarget", "ctrllevel", "ruleguid", "creater", "createtime", "lasttime", "lastuser", "version"  from boss_t_pay_busvou_acctmdl a left join (select DISTINCT code ,year from fasp_t_pubadmdiv where year = 2020 and province= '610000' and code  != '610000' and length(code) = 6) b on  a.year = b.year where a.year =2020 and a.province = '610000';

--去除暂存科目
delete from boss_t_pay_busvou_acctmdl where accountguid = 'B8739E94648744DC852495AE072D69E7'  and  year = 2020;

--修改 141003 与006 的记账模板
update p#fasp_t_pavoucher t set t.bctypeid='AF5D2CFA27B2E913B7CC9F19F33EDEC2' where code in('141003','141006')  and year=2020;

--增加月结函数及建表
drop table if EXISTS public.boss_t_pay_monthly_balance;

create table public.boss_t_pay_monthly_balance
(
  year       VARCHAR2(4) not null,
  month      NUMBER(2),
  closingtim VARCHAR2(40)
);




CREATE OR REPLACE FUNCTION  public.pay_gl_close_month_end()
 RETURNS void
 LANGUAGE plpgsql
  NOT FENCED NOT SHIPPABLE
  AS $$
DECLARE
  set_year          varchar2(10);
  is_continue   number := 1;
  set_month         number(4) := 0;
  month_current number(4);
  type t_cur is ref cursor;
  month_cur   t_cur;
  month_data  varchar2(1000);
  account_cur t_cur;
  account_id varchar2(38);
  insert_balance_sql varchar2(1000);
  update_money_sql   varchar2(2000);
  update_month_sql   varchar2(100);
  insert_month_sql   varchar2(1000);
begin
  select to_char(sysdate, 'yyyy') into set_year from dual;

  if (is_continue = 1) then
    open month_cur for 'select nvl(max(month),''0'') set_month from boss_t_pay_monthly_balance where year= :year'
      using set_year;
    loop
      fetch month_cur
        into month_data;
      exit when month_cur%notfound;
      set_month := month_data;
    end loop;
    select to_number(to_char(sysdate, 'mm')) into month_current from dual;
    if (month_current < set_month + 1) then
      is_continue := 0;
      dbms_output.put_line(month_current || '月份，已月结！');
    end if;
    ----添加新月份开始---
    if (month_current = set_month + 1) then
      execute immediate 'delete boss_t_pay_monthly_balance where month=' || set_month;
    end if;
    ----添加结束---
  end if;
  if (is_continue = 1) then
    open account_cur for 'select distinct  guid as account_id from boss_t_pay_account where year = ''' || set_year || ''' and BALANCEPERIODTYPE = ''1''';
    loop
      fetch account_cur
        into account_id;
      exit when account_cur%notfound;
      insert_balance_sql := 'insert into boss_t_pay_balance(accountguid,sumguid,createtime,lasttime,year,month,version,fromctrlid,rcid,ccid,province,guid) (select max(accountguid), sumguid, min(createtime), max(lasttime), max(year), :month_current,  max(version), max(fromctrlid), max(rcid), max(ccid), max(province), max(guid) from boss_t_pay_balance_month d where d.accountguid = :account_id and d.month <= :month_current and not exists (select 1 from boss_t_pay_balance b where b.accountguid = :account_id and b.sumguid = d.sumguid and b.year =d.year and b.province = d.province) group by sumguid)';
      execute immediate insert_balance_sql
        using month_current, account_id, month_current,account_id;
      update_money_sql := 'update boss_t_pay_balance b set (b.aviamt, b.useamt, b.minusamt, b.avingamt) = (select nvl(sum(m.aviamt), 0), nvl(sum(m.useamt), 0), nvl(sum(m.minusamt), 0), nvl(sum(m.avingamt), 0) from boss_t_pay_balance_month m where b.sumguid = m.sumguid and b.year = m.year  and m.year = :year and b.province= m.province and m.accountguid =:account_id and m.month <= :month_current) where b.accountguid = :account_id and exists (select 1 from boss_t_pay_balance_month d where d.sumguid = b.sumguid and d.month <= :month_current and d.year=b.year and d.province = b.province)';
      execute immediate update_money_sql
        using set_year, account_id, month_current, account_id, month_current;
      update_month_sql := 'update boss_t_pay_balance set month=:month_current where accountguid=:account_id and year= :year';
      execute immediate update_month_sql
        using month_current, account_id,set_year;
    end loop;
    insert_month_sql := 'insert into boss_t_pay_monthly_balance values(:year,:month,to_char(sysdate,''yyyy-mm-dd hh24:mi:ss''))';
    execute immediate insert_month_sql
      using set_year, month_current - 1;
  --  commit;
  end if;
  end $$


